
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Accessing serial values in a PowerBuilder script</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp51.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp53.htm" >Next</A>
<!-- End Header -->
<A NAME="CHEFGEII"></A><h1>Accessing serial values in a PowerBuilder script</h1>
<A NAME="TI1021"></A><p>If you are connecting to an Informix database from a PowerBuilder
script, you can obtain the serial number of the row inserted into
an Informix table by checking the value of the <ACRONYM title = "sequel return data" >SQLReturnData</ACRONYM> property
of the Transaction object.</p>
<A NAME="TI1022"></A><p>After an embedded <ACRONYM title = "sequel" >SQL</ACRONYM> <b>INSERT</b> statement
executes, <ACRONYM title = "sequel return data" >SQLReturnData</ACRONYM> contains the
serial number that uniquely identifies the row inserted into the
table.</p>
<A NAME="TI1023"></A><p>PowerBuilder updates <ACRONYM title = "sequel return data" >SQLReturnData</ACRONYM> following
an embedded <ACRONYM title = "sequel" >SQL</ACRONYM> statement only;
it does not update it following a DataWindow operation.</p>

